Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

Tesco Groceries
Software; Phone apps

Tesco Grocery is a Google Glassware software lets you ...

Moving Picture Experts Group 1 (MPEG-1)
Software; Video editing

ISO/IEC CD 11172 is the first of the standards designed for ...

Adobe Illustrator
Software; Graphic design software

A graphic design software produced by Adobe Systems using ...

Truth Goggles
Software; Analysis software

In-development software, developed by MIT student Dan ...

bone tool
Software; Graphic design software

Inverse kinematics (IK) is a method for animating an object ...

property keyframe
Software; Graphic design software

A property keyframe is a frame within a tween span where ...

Creator

Featured blossaries

Video Games Genres

Category: Entertainment   1 1 Terms

Hiking Trip

Category: Sports   1 6 Terms

Photograpy Framing

Category: Arts   1 55 Terms

Azazeel

Category: Literature   1 3 Terms

Futures Terms and Definitions

Category: Business   2 20 Terms

Table Tennis Ball

Category: Sports   1 5 Terms

TermWiki is ranked top innovative application by IDC.

© 2025 CSOFT International, Ltd.   

Follow us on: